package com.xpgk.mvc.statistic.semployee;

import java.io.UnsupportedEncodingException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.bouncycastle.crypto.tls.MACAlgorithm;

import com.jfinal.aop.Before;
import com.jfinal.log.Log;
import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Record;
import com.jfinal.plugin.activerecord.tx.Tx;
import com.xpgk.annotation.Service;
import com.xpgk.constant.ConstantRender;
import com.xpgk.dto.RenderBean;
import com.xpgk.mvc.base.BaseService;
import com.xpgk.mvc.bloseWeight.DelWeiTarget;
import com.xpgk.mvc.statistic.dailyNursing.DailyNursingStatisticSQL;
import com.xpgk.mvc.statistic.loseWeightList.LoseWeightListSQL;
import com.xpgk.mvc.statistic.spropagandaTraining.SpropagandaTrainingSQL;
import com.xpgk.tools.ToolDateTime;


@Service(name = SemployeeService.serviceName)
public class SemployeeService extends BaseService{

	@SuppressWarnings("unused")
	private static final Log log = Log.getLog(SemployeeService.class);
	public static final String serviceName = "semployeeService";
	
	
	/*
	 * 顾客数据查询
	 */
	
	public List<Record> customerDataQuey(String organIdsEmployee,String name) throws Exception{
	
		name = new String(name.getBytes("iso8859-1"),"utf-8");
		
		HashMap<String,Object> map = new HashMap<String,Object>();
		map.put("organIdsEmployee", organIdsEmployee);
		map.put("nameid", name);
		String sql = SemployeeSQL.semployee_excel;
		List<Record> result = find(sql,map);
		
		return result;
	}
}
